-- DWD层营销活动主题相关表
-- 广告投放数据表
create external table if not exists dwd_nshop.dwd_nshop_releasedatas
(
    customer_id          string comment '用户id',
    device_num           string comment '设备号',
    device_type          string comment '设备类型',
    os                   string comment '手机系统',
    os_version           string comment '手机系统版本',
    manufacturer         string comment '手机制造商',
    area_code            string comment '地区编码',
    release_sid          string comment '投放请求id',
    release_ip           string comment '投放方ip',
    release_session      string comment '投放会话id',
    release_sources      string comment '投放渠道',
    release_category     string comment '投放浏览产品分类',
    release_product      string comment '投放浏览产品',
    release_product_page string comment '投放浏览产品页',
    ct                   bigint comment '创建时间'
) partitioned by (bdp_day string)
    stored as parquet
    location '/data/nshop/dwd/release/dwd_nshop_releasedatas/';

show functions ;

desc function date_add;
